#!/bin/bash

#MYSQL="/usr/local/mysql/bin/mysql -P3306 -h 10.245.75.74 -u root -psdt543gogogo1"
MYSQL="/usr/local/mysql/bin/mysql -P3306 -h 192.168.117.100 -u root -p123456"
DB="db2_filterd"
TB="t_filterd"

$MYSQL -e "drop database if exists $DB;create database $DB;"
$MYSQL -e "use $DB;
	drop table if exists $TB;
	create table $TB(
	id int unsigned not null auto_increment primary key,
	type int unsigned not null,
	word varchar(100) not null,
	level int unsigned not null
	)engine=myisam default charset=gbk;"
